<%@ page language="java" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
  	<%@include file="/pages/include/base-head.jsp"%>
  </head>
  <body>
	<form id="add-form" class="dialog-data-form">
	  	<script type="text/javascript" src="${skin}/js/system/reports-add.js"></script>
    	<table class="data-table pull-left" cellspacing="2">
    		<tbody>
    			<tr>
    				<td class="field">SQL名称</td>
    				<td>
    					<input name="name" value='查询菜品id和菜品数量' type="text" class="field exportadd-input" maxlength="16"
    						data-options="required:true,validType:'fn[report.form.checkName]',invalidMessage:'SQL名称已存在！'"/>
    				</td>
    			</tr>
    			<tr>
					<td class="field">SQL语句</td>
    				<td>
    					<textarea name="hsql" id="hsql" class="field exportadd-input"
    					data-options="validType:'length[0,120]',invalidMessage:'不能超过120个字符！'">
    					select quantity, food_id from md_order_food where order_id in
    					 (select order_id from md_order where order_time>=:orderTime1: and order_time<=:orderTime2: and state=:state1: or state=:state2:)</textarea>
    					<p class="tips">ps："："冒号+参数名代表完整参数。</p>
    				</td>
    			</tr>
    			<tr>
					<td class="field">SQL描述</td>
					<td colspan="3">
						<textarea class="field-description exportadd-input" name="description" 
							data-options="validType:'length[0,120]',invalidMessage:'不能超过120个字符！'"></textarea>
					</td>
				</tr>
    		</tbody>
    	</table>
    	
    	<table class="data-list pull-left" id="addDatagrid">
			
    	</table>
   	</form>
  </body>
</html>
